select email_address, email_address_pp, business_name, order_status from orders where marketing_email != -1 and (email_address = 'vikoko@gmail.com' or email_address_pp = 'vikoko@gmail.com' ) and ((email_address or email_address_pp) not in (select email_sent_to from emails_sent_log where product_sku = '')) group by email_address, email_address_pp, business_name, order_status limit 1;